MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Alpha Sort = 13186

View and edit SQL

Suggested facets: Object Name, Title, Period, Object Date, Object Begin Date, Object End Date, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
149682 14.105.7 0 0 248886 Greek and Roman Art 12 Kylix, fragmentary 10967 Fragmentary terracotta kylix (drinking cup) Greek, Attic 4006 Classical         Attributed to the Triptolemos Painter     Triptolemos Painter 13186       ca. 460 B.C. -460 -460 Terracotta 160 diameter 5 1/4in. (13.4cm) Rogers Fund, 1914                       Vases 410   Metropolitan Museum of Art, New York, NY 1
156104 1973.175.3 0 0 255518 Greek and Roman Art 12 Kantharos fragment 12467 Kantharos fragment Greek, Attic 4006 Late Archaic         Attributed to the Triptolemos Painter     Triptolemos Painter 13186       ca. 490 B.C. -490 -490 Terracotta 160 greatest dim. 5.00 cm. Gift of Dietrich von Bothmer, 1973                       Vases 410   Metropolitan Museum of Art, New York, NY 1
156165 1977.16.2a–c 0 0 255584 Greek and Roman Art 12 Kylix fragments 10857 Kylix fragments Greek, Attic 4006 Classical         Attributed to the Triptolemos Painter     Triptolemos Painter 13186       ca. 480 B.C. -480 -480 Terracotta 160   Gift of Dietrich von Bothmer, 1977                       Vases 410   Metropolitan Museum of Art, New York, NY 1
156215 1978.347.5 0 0 255638 Greek and Roman Art 12 Kylix, fragmentary 10967 Fragmentary terracotta kylix (drinking cup) Greek, Attic 4006 Classical         Attributed to the Triptolemos Painter     Triptolemos Painter 13186       ca. 480 B.C. -480 -480 Terracotta 160 11 7/8 in. (30.2 cm) Gift of Dietrich von Bothmer, 1978                       Vases 410   Metropolitan Museum of Art, New York, NY 1
156255 1980.11.8a–e 0 0 255679 Greek and Roman Art 12 Kylix fragments 10857 Kylix fragments Greek, Attic 4006 Classical         Attributed to the Triptolemos Painter     Triptolemos Painter 13186       ca. 480 B.C. -480 -480 Terracotta 160 6 1/2 × 9 in. (16.5 × 22.9 cm) Purchase, Art Tours of Manhattan Inc., Arthur Darby Nock, in memory of Gisela M. A. Richter, Smith/Greenland Inc., Mr. and Mrs. Stuart Tray, and Anonymous Gifts, and David Tunick Gift in memory of his daughter, Allison Hope Tunick, 1980                       Vases 410   Metropolitan Museum of Art, New York, NY 1
156395 1985.60.2 0 0 255837 Greek and Roman Art 12 Stamnos fragment 12566 Stamnos fragment Greek, Attic 4006 Late Archaic         Attributed to the Triptolemos Painter     Triptolemos Painter 13186       ca. 490 B.C. -490 -490 Terracotta 160   Gift of Dietrich von Bothmer, 1985                       Vases 410   Metropolitan Museum of Art, New York, NY 1
156400 1985.201.2 0 0 255842 Greek and Roman Art 12 Stamnos fragment 12566 Stamnos fragment Greek, Attic 4006 Classical         Attributed to the Triptolemos Painter     Triptolemos Painter 13186       ca. 480 B.C. -480 -480 Terracotta 160   Gift of Dietrich von Bothmer, 1985                       Vases 410   Metropolitan Museum of Art, New York, NY 1
156428 1986.99.1a–p 0 0 255871 Greek and Roman Art 12 Kantharos fragments 12624 Kantharos fragments Greek, Attic 4006 Late Archaic         Attributed to the Triptolemos Painter     Triptolemos Painter 13186       ca. 490 B.C. -490 -490 Terracotta 160 container - fragmentary : 5 5/8 × 4 1/2 in. (14.3 × 11.4 cm) Gift of Dietrich von Bothmer, 1986                       Vases 410   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 124.001ms · Data license: CC0 · Data source: metmuseum/openaccess